select * from PhieuNhapThuocChiTiet where GiaNhap=0
delete from PhieuNhapThuocChiTiet where GiaNhap=0

update PhieuNhapThuocChiTiet set PhieuNhapThuocChiTiet.GiaXuat = PhieuXuatThuocChiTiet.GiaXuat from PhieuNhapThuocChiTiet
inner join PhieuXuatThuocChiTiet on PhieuXuatThuocChiTiet.idPhieuNhapChiTiet = PhieuNhapThuocChiTiet.idPhieuNhapChiTiet
